﻿<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPageContent.master" AutoEventWireup="true" CodeFile="EmployeeTVB.aspx.vb" Inherits="EmployeeTVB" %>

<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>

<%@ Register src="~/UserControls/OneFilteredDropDownList.ascx" tagname="OneFilteredDropDownList" tagprefix="uc1" %>

<%@ Register src="~/UserControls/Employees.ascx" tagname="EditTemplate" tagprefix="uc2" %>

<%@ MasterType TypeName="ContentMasterPage" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">


<script type="text/javascript" >

    function clientButtonClicking(sender, args) {
        var toolBar = sender;
        var button = args.get_item();
        if (button.get_value() == "Delete") {

            if (confirm('Are You Sure you Want to Delete ?')) {
                args.set_cancel(false);
            }
            else {
                args.set_cancel(true);
            }
        }
        else if (button.get_value() == "Print") {
            PrintRadGrid();
            args.set_cancel(true);
        }
    }

    function getOuterHTML(obj) {
        if (typeof (obj.outerHTML) == "undefined") {
            var divWrapper = document.createElement("div");
            var copyOb = obj.cloneNode(true);
            divWrapper.appendChild(copyOb);
            return divWrapper.innerHTML
        }
        else
            return obj.outerHTML;
    }

    function PrintRadGrid() {
        var previewWnd = window.open('about:blank', '', '', false);
        var sh = '<%= ClientScript.GetWebResourceUrl(rgEmployee.GetType(),String.Format("Telerik.Web.UI.Skins.{0}.Grid.{0}.css",rgEmployee.Skin)) %>';
        var shBase = '<%= ClientScript.GetWebResourceUrl(rgEmployee.GetType(),"Telerik.Web.UI.Skins.Grid.css") %>';
        var styleStr = "<html><head><link href = '" + sh + "' rel='stylesheet' type='text/css'></link>";
        styleStr += "<link href = '" + shBase + "' rel='stylesheet' type='text/css'></link></head>";
        var htmlcontent = styleStr + "<body>" + getOuterHTML($find('<%= rgEmployee.ClientID %>').get_element()) + "</body></html>";
        previewWnd.document.open();
        previewWnd.document.write(htmlcontent);
        previewWnd.document.close();
        previewWnd.print();

        if (!$telerik.isChrome) {
            previewWnd.close();
        }
    }

</script>


</asp:Content>




<asp:Content ID="Header" ContentPlaceHolderID="HeaderPlaceHolder" runat="server">



    <telerik:RadToolBar
            ID="rtMain" runat="server"
            style="z-index:90001" Width="100%" OnClientButtonClicking="clientButtonClicking"
            Skin="Office2007" EnableRoundedCorners="true" EnableShadows="true" >
            <Items>

    <telerik:RadToolBarButton Value="AddNew" ImageUrl="~/Design/ToolBar/addnew.png" ImagePosition="AboveText" Text="<%$ Resources:Toolbar, AddNew %>" ></telerik:RadToolBarButton>
                <telerik:RadToolBarButton IsSeparator="true" />
                <telerik:RadToolBarButton Value="Edit" ImageUrl="~/Design/ToolBar/edit.png" ImagePosition="AboveText" Text="<%$ Resources:Toolbar, Edit %>" ></telerik:RadToolBarButton>
                <telerik:RadToolBarButton IsSeparator="true" />
                <telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Value="Save" ImageUrl="~/Design/ToolBar/save.png" ImagePosition="AboveText" Text="<%$ Resources:Toolbar, Save %>" ></telerik:RadToolBarButton>
                <telerik:RadToolBarButton IsSeparator="true" />
                <telerik:RadToolBarButton Value="Cancel" ImageUrl="~/Design/ToolBar/cancel.png" ImagePosition="AboveText" Text="<%$ Resources:Toolbar, Cancel %>" ></telerik:RadToolBarButton>
                <telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Value="Delete" ImageUrl="~/Design/ToolBar/delete.png" ImagePosition="AboveText" Text="<%$ Resources:Toolbar, Delete %>" ></telerik:RadToolBarButton>
                <telerik:RadToolBarButton IsSeparator="true" />
                <telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton ImageUrl="~/Design/ToolBar/followup.png" ImagePosition="AboveText" Text="<%$ Resources:Toolbar, FollowUp %>" ></telerik:RadToolBarButton>
                <telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton ImageUrl="~/Design/ToolBar/refresh.png" ImagePosition="AboveText" Text="<%$ Resources:Toolbar, Refresh %>" ></telerik:RadToolBarButton>
                <telerik:RadToolBarButton IsSeparator="true" />
                <telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" /><telerik:RadToolBarButton Enabled="false" />
                <telerik:RadToolBarButton Value="Print" ImageUrl="~/Design/ToolBar/print.png" ImagePosition="AboveText" Text="<%$ Resources:Toolbar, Print %>" ></telerik:RadToolBarButton>
                <telerik:RadToolBarButton IsSeparator="true" />
                <telerik:RadToolBarDropDown Text="<%$ Resources:Toolbar, Export %>" ImageUrl="~/Design/ToolBar/export.png">
                    <Buttons>
                        <telerik:RadToolBarButton Value="pdf" Text="<%$ Resources:Toolbar, pdf %>" Height="22px" ImageUrl="~/Design/ToolBar/pdf.png" />
                        <telerik:RadToolBarButton Value="word" Text="<%$ Resources:Toolbar, word %>" Height="22px" ImageUrl="~/Design/ToolBar/word.png" />
                        <telerik:RadToolBarButton Value="excel" Text="<%$ Resources:Toolbar, excel %>" Height="22px" ImageUrl="~/Design/ToolBar/excel.png" />
                        <telerik:RadToolBarButton Value="csv" Text="<%$ Resources:Toolbar, csv %>" Height="22px" ImageUrl="~/Design/ToolBar/csv.png" />
                    </Buttons>
                </telerik:RadToolBarDropDown>
            </Items>
        </telerik:RadToolBar>


</asp:Content> 



<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<table  style="table-layout: fixed; ">

<tr><td>

        <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
            <AjaxSettings>
                <telerik:AjaxSetting AjaxControlID="rgEmployee">
                    <UpdatedControls>
                        <telerik:AjaxUpdatedControl ControlID="rgEmployee" LoadingPanelID="RadAjaxLoadingPanel1"/>
                        <telerik:AjaxUpdatedControl ControlID="rtMain" />                    
                    </UpdatedControls>
                </telerik:AjaxSetting>
                <telerik:AjaxSetting AjaxControlID="rtMain">
                    <UpdatedControls>
                        <telerik:AjaxUpdatedControl ControlID="rgEmployee" LoadingPanelID="RadAjaxLoadingPanel1"/>
                        <telerik:AjaxUpdatedControl ControlID="EmployeesForm" LoadingPanelID="RadAjaxLoadingPanel1"/>
                    </UpdatedControls>
                </telerik:AjaxSetting>
            </AjaxSettings>
        </telerik:RadAjaxManager>
        <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Telerik" Transparency="20">
        </telerik:RadAjaxLoadingPanel>

<br />

</td></tr>
</table>

<telerik:RadGrid ID="rgEmployee" runat="server" GridLines="None" DataSourceID="odsEmployee"
                    AllowAutomaticDeletes="True" AllowAutomaticInserts="True" SkinID="rgSkin"
        Width="100%" AllowAutomaticUpdates="True" OnItemDataBound="rgEmployee_ItemDataBound" AllowFilteringByColumn="true"
                    AutoGenerateColumns="False" MasterTableView-Dir="<%$ Resources:SystemResource, HTMLDirectionality %>"
                    GroupPanel-Text="<%$ Resources:MainGrid ,GroupPanelText %>" CellSpacing="0">
                    <MasterTableView Width="100%" DataKeyNames="EMP_ID" CommandItemSettings-ShowAddNewRecordButton="false" CommandItemDisplay="Top"
                        TableLayout="Fixed" DataSourceID="odsEmployee" HorizontalAlign="NotSet" CommandItemSettings-ShowRefreshButton="false"
                        NoMasterRecordsText="<%$ Resources:MainGrid , NoMasterRecordsText %>">
                        <%--<CommandItemTemplate>
                        <table runat="server" dir="<%$ Resources:SystemResource, HTMLDirectionality %>">
                        <tr>
                        <td>
                        
                         <asp:ImageButton  id="ibtnInitInsert" CommandName="InitInsert"  runat="server"  ImageUrl="Design/images/Grid/AddRecord.gif"  />                          
                            &nbsp;&nbsp;
                             <asp:LinkButton ID="lbtnInitInsert" runat="server" Font-Size="Large" Text="<%$ Resources:MainGrid , AddNew %>"
                                CommandName="InitInsert" Visible="true" />&nbsp;&nbsp;&nbsp;&nbsp;
                            
                            <asp:ImageButton  id="ibtnEditSelected" CommandName="EditSelected"  runat="server"  ImageUrl="Design/images/Grid/Edit.gif"  />
                            &nbsp;&nbsp;
                            <asp:LinkButton ID="lbtnEditSelected" runat="server" Font-Size="Large" Text="<%$ Resources:MainGrid , EditSelected %>"
                                CommandName="EditSelected" Visible="true" />&nbsp;&nbsp;&nbsp;&nbsp;
                            
                            <asp:ImageButton  id="ibtnDeleteSelected" CommandName="DeleteSelected"  runat="server"  ImageUrl="Design/images/Grid/Delete.gif"  />&nbsp;&nbsp;
                            <asp:LinkButton
                                ID="lbtnDeleteSelected" Font-Size="Large" OnClientClick="<%$ Resources:MainGrid , OnClientClickDelete %>"
                                runat="server" Text="<%$ Resources:MainGrid , DeleteSelected %>" CommandName="DeleteSelected" />&nbsp;&nbsp;&nbsp;&nbsp;
                            
                            <asp:ImageButton  id="ibtnRebindGrid" CommandName="DeleteSelected"  runat="server"  ImageUrl="Design/images/Grid/Refresh.gif"  />&nbsp;&nbsp;
                            <asp:LinkButton
                                ID="lbtnRebindGrid" Font-Size="Large" runat="server" Text="<%$ Resources:MainGrid , Refresh %>"
                                CommandName="RebindGrid" />
                        </td>
                        </tr>
                        </table>
                        </CommandItemTemplate>--%>
                        <Columns>
                            <%--<telerik:GridEditCommandColumn ButtonType="ImageButton">
                                <ItemStyle CssClass="MyImageButton" />
                                <HeaderStyle Width="50px" />
                            </telerik:GridEditCommandColumn>--%>
                            <telerik:GridBoundColumn DataField="EMP_ID" meta:ResourceKey="gbcEMP_ID" ReadOnly="True" SortExpression="EMP_ID"
                                UniqueName="EMP_ID" Visible="false">
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="emp_Num" meta:ResourceKey="gbcemp_Num" ReadOnly="True" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true"
                                SortExpression="emp_Num" UniqueName="emp_Num" Visible="True" AllowFiltering="true" ShowFilterIcon="false" FilterControlWidth="50px">
                                 <HeaderStyle Width="70px" />
                                <ItemStyle Width="70px" />
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="FName" meta:ResourceKey="gbcFName" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true"
                                SortExpression="FName" UniqueName="FName" AllowFiltering="true" ShowFilterIcon="false" FilterControlWidth="50px" >
                                <HeaderStyle Width="70px" />
                                <ItemStyle Width="70px" />
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="LName" meta:ResourceKey="gbcLName" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true"
                                SortExpression="LName" UniqueName="LName" AllowFiltering="true" ShowFilterIcon="false" FilterControlWidth="50px">
                                <HeaderStyle Width="70px" />
                                <ItemStyle Width="70px" />
                            </telerik:GridBoundColumn>
                            <telerik:GridDropDownColumn AllowFiltering="true" DataField="Emp_Type" DataSourceID="odsEmp_Type" meta:ResourceKey="gbcEmp_Type"
                                ListTextField="<%$ Resources:SystemResource, rcbLookup %>" ListValueField="MINOR" UniqueName="Emp_Type"  EnableEmptyListItem = "true" EmptyListItemText="-" EmptyListItemValue="">
                                <HeaderStyle Width="100px" />
                                <ItemStyle Width="100px" />

                                <FilterTemplate>
                                    <center>
                                    <telerik:RadComboBox ID="rcbFilterEmp_Type" DataSourceID="odsEmp_Type" DataTextField="<%$ Resources:SystemResource, rcbLookup %>" Width="80px"
                                        DataValueField="MINOR" Height="70px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("Emp_Type").CurrentFilterValue %>'
                                        runat="server" OnClientSelectedIndexChanged="Emp_TypeIndexChanged">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    </center>
                                    <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">

                                        <script type="text/javascript">
                                            function Emp_TypeIndexChanged(sender, args) {
                                                var tableView = $find("<%# TryCast(Container,GridItem).OwnerTableView.ClientID %>");
                                                tableView.filter("Emp_Type", args.get_item().get_value(), "EqualTo");
                                            }
                                        </script>

                                    </telerik:RadScriptBlock>
                            </FilterTemplate>


                            </telerik:GridDropDownColumn>

                             <telerik:GridDropDownColumn DataField="Emp_Type" DataSourceID="odsEmp_Type" HeaderText="Type"
                                ListTextField="MINOR" ListValueField="MINOR" UniqueName="Emp_Type_ID" EnableEmptyListItem="True" Visible ="false" >
                          </telerik:GridDropDownColumn>


                              <telerik:GridDropDownColumn DataField="Gender" DataSourceID="odsGender" meta:ResourceKey="gbcGender"
                                ListTextField="<%$ Resources:SystemResource, rcbLookup %>" ListValueField="MINOR" UniqueName="Gender" EnableEmptyListItem = "true" EmptyListItemText="-" EmptyListItemValue="">
                                <HeaderStyle Width="90px" />
                                <ItemStyle Width="90px" />

                                <FilterTemplate>
                                    <center>
                                    <telerik:RadComboBox ID="rcbFilterGender" AllowFiltering="true" DataSourceID="odsGender" DataTextField="<%$ Resources:SystemResource, rcbLookup %>" Width="80px"
                                        DataValueField="MINOR" Height="70px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("Gender").CurrentFilterValue %>'
                                        runat="server" OnClientSelectedIndexChanged="GenderIndexChanged">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    </center>
                                    <telerik:RadScriptBlock ID="RadScriptBlock2" runat="server">

                                        <script type="text/javascript">
                                            function GenderIndexChanged(sender, args) {
                                                var tableView = $find("<%# TryCast(Container,GridItem).OwnerTableView.ClientID %>");
                                                tableView.filter("Gender", args.get_item().get_value(), "EqualTo");
                                            }
                                        </script>

                                    </telerik:RadScriptBlock>
                            </FilterTemplate>

                            </telerik:GridDropDownColumn>
                             <telerik:GridDropDownColumn DataField="Gender" DataSourceID="odsGender" HeaderText="Gender"
                                ListTextField="MINOR" ListValueField="MINOR" UniqueName="Gender_ID" EnableEmptyListItem="True" Visible ="false" >

                            </telerik:GridDropDownColumn>

                                <telerik:GridDateTimeColumn UniqueName="DateofBirth" Visible="false"  SortExpression="DateofBirth" AllowFiltering="false" meta:ResourceKey="gbcDateofBirth" DataField="DateofBirth" DataFormatString="{0:d}" >
                                <HeaderStyle Width="90px" />
                                <ItemStyle Width="90px" />
                                </telerik:GridDateTimeColumn>
                            <telerik:GridDropDownColumn DataField="Designation" DataSourceID="odsDesignation" meta:ResourceKey="gbcDesignation"
                                ListTextField="<%$ Resources:SystemResource, rcbLookup %>" ListValueField="MINOR" UniqueName="Designation"  EnableEmptyListItem = "true" EmptyListItemText="-" EmptyListItemValue="">
                                <HeaderStyle Width="100px" />
                                <ItemStyle Width="100px" />

                                <FilterTemplate>
                                    <center>
                                    <telerik:RadComboBox ID="rcbFilterDesignation" AllowFiltering="true" DataSourceID="odsDesignation" DataTextField="<%$ Resources:SystemResource, rcbLookup %>" Width="85px"
                                        DataValueField="MINOR" Height="200px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("Designation").CurrentFilterValue %>'
                                        runat="server" OnClientSelectedIndexChanged="DesignationIndexChanged">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    </center>
                                    <telerik:RadScriptBlock ID="RadScriptBlock3" runat="server">

                                        <script type="text/javascript">
                                            function DesignationIndexChanged(sender, args) {
                                                var tableView = $find("<%# TryCast(Container,GridItem).OwnerTableView.ClientID %>");
                                                tableView.filter("Designation", args.get_item().get_value(), "EqualTo");
                                            }
                                        </script>

                                    </telerik:RadScriptBlock>
                               </FilterTemplate>

                            </telerik:GridDropDownColumn>

                           <telerik:GridDropDownColumn DataField="Designation" DataSourceID="odsDesignation" HeaderText="Designation"
                                ListTextField="MINOR" ListValueField="MINOR" UniqueName="Designation_ID" EnableEmptyListItem="True" Visible ="false" >
                            </telerik:GridDropDownColumn>

                           <telerik:GridDropDownColumn  DataField="CompanyGroup" DataSourceID="odsCompanyGroup" meta:ResourceKey="gbcCompanyGroup"
                                ListTextField="<%$ Resources:SystemResource, rcbLookup %>" ListValueField="MINOR" UniqueName="CompanyGroup"  EnableEmptyListItem = "true" EmptyListItemText="-" EmptyListItemValue="">
                                <HeaderStyle Width="100px" />
                                <ItemStyle Width="100px" />

                                <FilterTemplate>
                                    <center>
                                    <telerik:RadComboBox ID="rcbFilterCompanyGroup" AllowFiltering="true" DataSourceID="odsCompanyGroup" DataTextField="<%$ Resources:SystemResource, rcbLookup %>" Width="85px"
                                        DataValueField="MINOR" Height="150px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("CompanyGroup").CurrentFilterValue %>'
                                        runat="server" OnClientSelectedIndexChanged="CompanyGroupIndexChanged">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    </center>
                                    <telerik:RadScriptBlock ID="RadScriptBlock4" runat="server">

                                        <script type="text/javascript">
                                            function CompanyGroupIndexChanged(sender, args) {
                                                var tableView = $find("<%# TryCast(Container,GridItem).OwnerTableView.ClientID %>");
                                                tableView.filter("CompanyGroup", args.get_item().get_value(), "EqualTo");
                                            }
                                        </script>

                                    </telerik:RadScriptBlock>
                               </FilterTemplate>

                            </telerik:GridDropDownColumn>

                           <telerik:GridDropDownColumn  DataField="CompanyGroup" DataSourceID="odsCompanyGroup" HeaderText="Company Group"
                                ListTextField="MINOR" ListValueField="MINOR" UniqueName="CompanyGroup_ID" EnableEmptyListItem="True" Visible ="false">

                            </telerik:GridDropDownColumn>
                           
                            <telerik:GridDropDownColumn DataField="Company" DataSourceID="odsCompany" meta:ResourceKey="gbcCompany"
                                ListTextField="<%$ Resources:SystemResource, rcbLookup %>" ListValueField="MINOR" UniqueName="Company"  EnableEmptyListItem = "true" EmptyListItemText="-" EmptyListItemValue="">
                                <HeaderStyle Width="100px" />
                                <ItemStyle Width="100px" />

                                <FilterTemplate>
                                    <center>
                                    <telerik:RadComboBox ID="rcbFilterCompany" DataSourceID="odsCompany" DataTextField="<%$ Resources:SystemResource, rcbLookup %>" Width="85px"
                                        DataValueField="MINOR" Height="200px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("Company").CurrentFilterValue %>'
                                        runat="server" OnClientSelectedIndexChanged="CompanyIndexChanged">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    </center>
                                    <telerik:RadScriptBlock ID="RadScriptBlock5" runat="server">

                                        <script type="text/javascript">
                                            function CompanyIndexChanged(sender, args) {
                                                var tableView = $find("<%# TryCast(Container,GridItem).OwnerTableView.ClientID %>");
                                                tableView.filter("Company", args.get_item().get_value(), "EqualTo");
                                            }
                                        </script>

                                    </telerik:RadScriptBlock>
                               </FilterTemplate>

                            </telerik:GridDropDownColumn>

                            <telerik:GridDropDownColumn DataField="Company" DataSourceID="odsCompany" HeaderText="Company"
                                ListTextField="MINOR" ListValueField="MINOR" UniqueName="Company_ID" EnableEmptyListItem="True" Visible ="false" >

                            </telerik:GridDropDownColumn>


                           <telerik:GridDropDownColumn DataField="Department" AllowFiltering="true" DataSourceID="odsDepartment" meta:ResourceKey="gbcDepartment"
                                ListTextField="<%$ Resources:SystemResource, rcbLookup %>" ListValueField="MINOR" UniqueName="Department"  EnableEmptyListItem = "true" EmptyListItemText="-" EmptyListItemValue="">
                                <HeaderStyle Width="100px" />
                                <ItemStyle Width="100px" />

                                <FilterTemplate>
                                    <center>
                                    <telerik:RadComboBox ID="rcbFilterDepartment" DataSourceID="odsDepartment" DataTextField="<%$ Resources:SystemResource, rcbLookup %>" Width="85px"
                                        DataValueField="MINOR" Height="200px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("Department").CurrentFilterValue %>'
                                        runat="server" OnClientSelectedIndexChanged="DepartmentIndexChanged">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    </center>
                                    <telerik:RadScriptBlock ID="RadScriptBlock6" runat="server">

                                        <script type="text/javascript">
                                            function DepartmentIndexChanged(sender, args) {
                                                var tableView = $find("<%# TryCast(Container,GridItem).OwnerTableView.ClientID %>");
                                                tableView.filter("Department", args.get_item().get_value(), "EqualTo");
                                            }
                                        </script>

                                    </telerik:RadScriptBlock>
                               </FilterTemplate>

                            </telerik:GridDropDownColumn>

                            
                           <telerik:GridDropDownColumn DataField="Department" DataSourceID="odsDepartment" HeaderText="Department"
                                ListTextField="MINOR" ListValueField="MINOR" UniqueName="Department_ID" EnableEmptyListItem="True" Visible ="false" >
                            </telerik:GridDropDownColumn>

                             <telerik:GridDropDownColumn DataField="Project" Visible="false" DataSourceID="odsProject" meta:ResourceKey="gbcProject"
                                ListTextField="<%$ Resources:SystemResource, rcbLookup %>" ListValueField="MINOR" UniqueName="Project"  EnableEmptyListItem = "true" EmptyListItemText="-" EmptyListItemValue="">
                                <HeaderStyle Width="100px" />
                                <ItemStyle Width="100px" />

                                <FilterTemplate>
                                    <center>
                                    <telerik:RadComboBox ID="rcbFilterProject" DataSourceID="odsProject" DataTextField="<%$ Resources:SystemResource, rcbLookup %>" Width="80px"
                                        DataValueField="MINOR" Height="150px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("Project").CurrentFilterValue %>'
                                        runat="server" OnClientSelectedIndexChanged="ProjectIndexChanged">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    </center>
                                    <telerik:RadScriptBlock ID="RadScriptBlock7" runat="server">

                                        <script type="text/javascript">
                                            function ProjectIndexChanged(sender, args) {
                                                var tableView = $find("<%# TryCast(Container,GridItem).OwnerTableView.ClientID %>");
                                                tableView.filter("Project", args.get_item().get_value(), "EqualTo");
                                            }
                                        </script>

                                    </telerik:RadScriptBlock>
                               </FilterTemplate>

                            </telerik:GridDropDownColumn>

                            <telerik:GridDropDownColumn DataField="Project" DataSourceID="odsProject" HeaderText="Project"
                                ListTextField="MINOR" ListValueField="MINOR" UniqueName="Project_ID" EnableEmptyListItem="True" EmptyListItemText="" Visible="false"  >
                            </telerik:GridDropDownColumn>

                           <telerik:GridDropDownColumn DataField="Emp_Status" AllowFiltering="true" DataSourceID="odsEmp_Status" meta:ResourceKey="gbcEmp_Status"
                                ListTextField="<%$ Resources:SystemResource, rcbLookup %>" ListValueField="MINOR" UniqueName="Emp_Status"  EnableEmptyListItem = "true" EmptyListItemText="-" EmptyListItemValue="">
                                <HeaderStyle Width="100px" />
                                <ItemStyle Width="100px" />

                                <FilterTemplate>
                                    <center>
                                    <telerik:RadComboBox ID="rcbFilterEmp_Status" DataSourceID="odsEmp_Status" DataTextField="<%$ Resources:SystemResource, rcbLookup %>" Width="80px"
                                        DataValueField="MINOR" Height="70px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("Emp_Status").CurrentFilterValue %>'
                                        runat="server" OnClientSelectedIndexChanged="Emp_StatusIndexChanged">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    </center>
                                    <telerik:RadScriptBlock ID="RadScriptBlock8" runat="server">

                                        <script type="text/javascript">
                                            function Emp_StatusIndexChanged(sender, args) {
                                                var tableView = $find("<%# TryCast(Container,GridItem).OwnerTableView.ClientID %>");
                                                tableView.filter("Emp_Status", args.get_item().get_value(), "EqualTo");
                                            }
                                        </script>

                                    </telerik:RadScriptBlock>
                               </FilterTemplate>

                            </telerik:GridDropDownColumn> 
                         <telerik:GridDropDownColumn DataField="Emp_Status" DataSourceID="odsEmp_Status" HeaderText="Status"
                                ListTextField="MINOR" ListValueField="MINOR" UniqueName="Emp_Status_ID" EnableEmptyListItem="True" Visible ="false" >

                            </telerik:GridDropDownColumn> 

                           
                            <%--<telerik:GridButtonColumn ConfirmText="<%$ Resources:MainGrid , ConfirmDelete %>"
                                ConfirmDialogType="RadWindow" ConfirmTitle="Delete" ButtonType="ImageButton"
                                CommandName="Delete" Text="Delete" UniqueName="DeleteColumn">
                                <HeaderStyle Width="50px" />
                                <ItemStyle Width="50px" HorizontalAlign="Center" CssClass="MyImageButton" />
                            </telerik:GridButtonColumn>--%>


                        </Columns>

                <EditFormSettings ColumnNumber="2" EditFormType="Template" CaptionDataField="emp_Num" CaptionFormatString="Edit properties of Employee # {0}" InsertCaption="New Employee">
                   <FormTableItemStyle Wrap="False"></FormTableItemStyle>
                    <FormCaptionStyle CssClass="EditFormHeader"></FormCaptionStyle>
                    <FormMainTableStyle GridLines="None" CellSpacing="0" CellPadding="3" BackColor="White"
                        Width="100%" />
                    <FormTableStyle CellSpacing="0" CellPadding="2" Height="110px" BackColor="White" />
                    <FormTableAlternatingItemStyle Wrap="False"></FormTableAlternatingItemStyle>
                    <EditColumn ButtonType="ImageButton" InsertText="Insert Employee" UpdateText="Update record"
                        UniqueName="EditCommandColumn1" CancelText="Cancel edit">
                    </EditColumn>
                    <FormTableButtonRowStyle HorizontalAlign="Left" CssClass="EditFormButtonRow"></FormTableButtonRowStyle>



                    <FormTemplate>
                    
                    
                    
                    
                    
                    
                    <table cellspacing="2" cellpadding="1" border="0" rules="none" >
                                    
                  <tr style="margin-bottom:40px">
                  <td>
                        <asp:Label ID="lblEdit" SkinID="KeyLabel" Font-Bold="true" Font-Italic="true" runat="server" Text='<%# IIf((TypeOf(Container) is GridEditFormInsertItem), "New Employee", "Edit Employee #") %>'></asp:Label> 
                  </td>

                  <td>
                   <telerik:RadTextBox ID="rtbemp_Num" runat="server" Width="250px" Skin="Sunset" 
                        Text='<%# Bind("emp_Num") %>' Enabled="false" Visible='<%# IIf((TypeOf(Container) is GridEditFormInsertItem), "False", "True") %>' > 
                       </telerik:RadTextBox>
                  </td>
                  </tr>
                     <tr>
                  <td>
                       <asp:Label ID="lblMantxtFName" runat="server" SkinID="Mandetory" Text="<%$ Resources:Controls, RequiredValidationText %>" ></asp:Label>
                       <asp:Label ID="lblFName" SkinID="KeyLabel" runat="server" meta:ResourceKey="lblFName" ></asp:Label>
                       &nbsp;&nbsp;
                  </td>
                  <td>
                       <telerik:RadTextBox ID="rtbFName" runat="server" Width="250px" Skin="Sunset" 
                        Text='<%# Bind("FName") %>'>
                       </telerik:RadTextBox> 
                   </td>
                   <td>
                        <asp:RequiredFieldValidator ID="rfvrtbFName" runat="server" ControlToValidate="rtbFName" ErrorMessage="<%$ Resources:Controls, ErrorMessage %>" ValidationGroup="valEditMode"></asp:RequiredFieldValidator>
                   </td>

                   <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                       <asp:Label ID="lblrcbCompanyGroup" SkinID="KeyLabel" runat="server" meta:ResourceKey="lblrcbCompanyGroup" ></asp:Label>
                        &nbsp;&nbsp;
                  </td>
                  <td>      
                       <uc1:onefiltereddropdownlist ID="rcbCompanyGroup" Runat="server" DataSourceID="odsCompanyGroup" 
                    DataTextField="<%$ Resources:SystemResource, rcbLookup %>" DataValueField="MINOR" IsRequired="false" 
                    DefaultChoosedItem="ChooseOne"  SelectedValue='<%# Bind("CompanyGroup") %>'/>
                   </td>


                  </tr>



                  <tr>
                  <td>
                       <asp:Label ID="lblMantxtLName" runat="server" SkinID="Mandetory" Text="<%$ Resources:Controls, RequiredValidationText %>" ></asp:Label>
                       <asp:Label ID="lblLName" SkinID="KeyLabel" runat="server" meta:ResourceKey="lblLName" ></asp:Label>
                        &nbsp;&nbsp;
                  </td>
                  <td>
                       <telerik:RadTextBox ID="rtbLName" Width="250px" runat="server" Skin="Sunset" 
                        Text='<%# Bind("LName") %>'>
                       </telerik:RadTextBox> 
                   </td>
                   <td>
                        <asp:RequiredFieldValidator ID="rfvrtbLName" runat="server" ControlToValidate="rtbLName" ErrorMessage="<%$ Resources:Controls, ErrorMessage %>" ValidationGroup="valEditMode"></asp:RequiredFieldValidator>
                   </td>


                   <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                       <asp:Label ID="lblrcbCompany" SkinID="KeyLabel" runat="server" meta:ResourceKey="lblrcbCompany" ></asp:Label>
                        &nbsp;&nbsp;
                  </td>
                  <td>      
                       <uc1:onefiltereddropdownlist ID="rcbCompany" Runat="server" DataSourceID="odsCompany" 
                    DataTextField="<%$ Resources:SystemResource, rcbLookup %>" DataValueField="MINOR" IsRequired="false" 
                    DefaultChoosedItem="ChooseOne"  SelectedValue='<%# Bind("Company") %>' ValidationGroup="valEditMode"/>
                   </td>


                  </tr>


                  <tr>
                  <td>
                       <asp:Label ID="lblrcbEmp_Type" SkinID="KeyLabel" runat="server" meta:ResourceKey="lblrcbEmp_Type" ></asp:Label>
                        &nbsp;&nbsp;
                  </td>
                  <td>      
                       <uc1:onefiltereddropdownlist ID="rcbEmp_Type" Runat="server" DataSourceID="odsEmp_Type" 
                    DataTextField="<%$ Resources:SystemResource, rcbLookup %>" DataValueField="MINOR" IsRequired="false" 
                     DefaultChoosedItem="ChooseOne" SelectedValue='<%# Bind("Emp_Type") %>'/>
                   </td>

                   <td> &nbsp; </td>
                   <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                       <asp:Label ID="lblrcbDepartment" SkinID="KeyLabel" runat="server" meta:ResourceKey="lblrcbDepartment" ></asp:Label>
                        &nbsp;&nbsp;
                  </td>
                  <td>      
                       <uc1:onefiltereddropdownlist ID="rcbDepartment" Runat="server" DataSourceID="odsDepartment" 
                    DataTextField="<%$ Resources:SystemResource, rcbLookup %>" DataValueField="MINOR" IsRequired="false" 
                    DefaultChoosedItem="ChooseOne" SelectedValue='<%# Bind("Department") %>'/>
                   </td>

                  </tr>

                  <tr>
                  <td>
                       <asp:Label ID="lblrcbGender" SkinID="KeyLabel" runat="server" meta:ResourceKey="lblrcbGender"  ></asp:Label>
                        &nbsp;&nbsp;
                  </td>
                  <td>      
                       <uc1:onefiltereddropdownlist ID="rcbGender" Runat="server" DataSourceID="odsGender" 
                    DataTextField="DescriptionEn" DataValueField="MINOR" IsRequired="false" 
                    DefaultChoosedItem="ChooseOne" SelectedValue='<%# Bind("Gender") %>'/>
                   </td>

                   <td> &nbsp; </td>
                   <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                       <asp:Label ID="lblrcbProject" SkinID="KeyLabel" runat="server" meta:ResourceKey="lblrcbProject" ></asp:Label>
                        &nbsp;&nbsp;
                  </td>
                  <td>      
                       <uc1:onefiltereddropdownlist ID="rcbProject" Runat="server" DataSourceID="odsProject" 
                    DataTextField="<%$ Resources:SystemResource, rcbLookup %>" DataValueField="MINOR" IsRequired="false" 
                    DefaultChoosedItem="ChooseOne" SelectedValue='<%# Bind("Project") %>'  ValidationGroup="valEditMode"/>
                   </td>

                   
                  </tr>

                  <tr>
                  <td>
                       <asp:Label ID="lblrcbDesignation" SkinID="KeyLabel" runat="server" meta:ResourceKey="lblrcbDesignation" ></asp:Label>
                        &nbsp;&nbsp;
                  </td>
                  <td>      
                       <uc1:onefiltereddropdownlist ID="rcbDesignation" Runat="server" DataSourceID="odsDesignation" 
                    DataTextField="<%$ Resources:SystemResource, rcbLookup %>" DataValueField="MINOR" IsRequired="false" 
                    DefaultChoosedItem="ChooseOne" SelectedValue='<%# Bind("Designation") %>'/>
                   </td>


                   <td> &nbsp; </td>
                   <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                       <asp:Label ID="lblrcbEmp_Status" SkinID="KeyLabel" runat="server" meta:ResourceKey="lblrcbStatus"  ></asp:Label>
                        &nbsp;&nbsp;
                  </td>
                  <td>      
                       <uc1:onefiltereddropdownlist ID="rcbEmp_Status" Runat="server" DataSourceID="odsEmp_Status" 
                    DataTextField="<%$ Resources:SystemResource, rcbLookup %>" DataValueField="MINOR" IsRequired="false" 
                    DefaultChoosedItem="ChooseOne" SelectedValue='<%# Bind("Emp_Status") %>'/>
                   </td>

                   
                  </tr>

                  </tr>

                  <tr>
                  <td>
                       <asp:Label ID="lblrdpDateOfBirth" SkinID="KeyLabel" runat="server" meta:ResourceKey="lblrdpDateOfBirth"  ></asp:Label>
                        &nbsp;&nbsp;
                  </td>
                  <td>      
                       <telerik:RadDatePicker runat="server" DbSelectedDate='<%# Bind("DateofBirth") %>' ID="rdpDateOfBirth" Culture="English (United States)" ShowPopupOnFocus="true">         
                        <DateInput ID="DateInput1" DateFormat="dd/MM/yyyy" runat="server"> 
                       </DateInput></telerik:RadDatePicker>
                   </td>
                   
                  </tr>


                  <tr>
                   
                   <td colspan="5" dir="ltr" style="margin-top:15px">
                   &nbsp;
                     <asp:ImageButton ID="ibtnbtnEdtInsert" ImageUrl="~/Design/images/Update.gif" runat="server" CommandName="PerformInsert" CausesValidation="true"  ValidationGroup="valEditMode" Text="Add" ToolTip="AddUser"  Visible='<%# IIf((TypeOf(Container) is GridEditFormInsertItem), "True", "False") %>'/>
                     <asp:ImageButton ID="ibtnbtnEdtUpdate" ImageUrl="~/Design/images/Update.gif" runat="server" CommandName="Update"  CausesValidation="true" ValidationGroup="valEditMode" Text="Update" ToolTip="Update"  Visible='<%# IIf((TypeOf(Container) is GridEditFormInsertItem), "False", "True") %>' />
                     <asp:ImageButton ID="ibtnbtnEdtCancel" ImageUrl="~/Design/images/Cancel.gif" runat="server" CommandName="Cancel" Text="Cancel" CausesValidation="False" ToolTip="Cancel" />                            
                   
                   </td>
                 </tr>


        </table>




                                           
                    
                    
                    </FormTemplate>


                    </EditFormSettings>

                        <RowIndicatorColumn>
                            <HeaderStyle Width="20px" />
                        </RowIndicatorColumn>
                        <ExpandCollapseColumn>
                            <HeaderStyle Width="20px" />
                        </ExpandCollapseColumn>
                        <HeaderStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                            Font-Underline="False" HorizontalAlign="Center" Wrap="True"   />
                    </MasterTableView>
                    <ValidationSettings CommandsToValidate="PerformInsert,Update" ValidationGroup="valEditMode" />
                    <GroupingSettings CaseSensitive="false" /> 
                    <ClientSettings AllowDragToGroup="False" EnablePostBackOnRowClick="true"> 
                        <Scrolling AllowScroll="false" ScrollHeight="400px"   />
                        <Selecting AllowRowSelect="True" />
                    </ClientSettings>
                    <FilterMenu EnableTheming="True" Skin="WebBlue">
                        <CollapseAnimation Duration="200" Type="OutQuint" />
                    </FilterMenu>
                </telerik:RadGrid>







        <uc2:EditTemplate ID="EmployeesForm" runat="server" Visible="false" />






        <asp:ObjectDataSource ID="odsEmployee" runat="server" 
    DeleteMethod="QueryDatabase" InsertMethod="QueryDatabase" 
    SelectMethod="QueryDatabase" TypeName="DBEmployeeSP" 
    UpdateMethod="QueryDatabase" OldValuesParameterFormatString="{0}">
    <DeleteParameters>
        <asp:Parameter DefaultValue="0"  Name="QueryType" Type="Object" />
        <asp:Parameter DefaultValue="deleteEmployee"  Name="Operation" Type="String" />
        <asp:Parameter Name="EMP_ID" Type="String" />
        <asp:Parameter Name="emp_Num" Type="String" />
        <asp:Parameter Name="FName" Type="String" />
        <asp:Parameter Name="LName" Type="String" />
        <asp:Parameter Name="Emp_Type" Type="String" />
        <asp:Parameter Name="Gender" Type="String" />
        <asp:Parameter Name="DateofBirth" Type="String" />
        <asp:Parameter Name="Designation" Type="String" />
        <asp:Parameter Name="CompanyGroup" Type="String" />
        <asp:Parameter Name="Company" Type="String" />
        <asp:Parameter Name="Department" Type="String" />
        <asp:Parameter Name="Project" Type="String" />
        <asp:Parameter Name="Emp_Status" Type="String" />
        <asp:Parameter Name="Remarks" Type="String" />
    </DeleteParameters>
    <InsertParameters>
        <asp:Parameter DefaultValue="0" Name="QueryType" Type="Object" />
        <asp:Parameter DefaultValue="SaveEmployee" Name="Operation" Type="String" />
        <asp:Parameter Name="EMP_ID" Type="String" />
        <asp:Parameter Name="emp_Num" Type="String" />
        <asp:Parameter Name="FName" Type="String" />
        <asp:Parameter Name="LName" Type="String" />
        <asp:Parameter Name="Emp_Type" Type="String" />
        <asp:Parameter Name="Gender" Type="String" />
        <asp:Parameter Name="DateofBirth" Type="String" />
        <asp:Parameter Name="Designation" Type="String" />
        <asp:Parameter Name="CompanyGroup" Type="String" />
        <asp:Parameter Name="Company" Type="String" />
        <asp:Parameter Name="Department" Type="String" />
        <asp:Parameter Name="Project" Type="String" />
        <asp:Parameter Name="Emp_Status" Type="String" />
        <asp:Parameter Name="Remarks" Type="String" />
    </InsertParameters>
    <SelectParameters>
        <asp:Parameter DefaultValue="1" Name="QueryType" Type="Object" />
        <asp:Parameter DefaultValue="RtvEmployee" Name="Operation" Type="String" />
        <asp:Parameter Name="EMP_ID" Type="String" />
        <asp:Parameter Name="emp_Num" Type="String" />
        <asp:Parameter Name="FName" Type="String" />
        <asp:Parameter Name="LName" Type="String" />
        <asp:Parameter Name="Emp_Type" Type="String" />
        <asp:Parameter Name="Gender" Type="String" />
        <asp:Parameter Name="DateofBirth" Type="String" />
        <asp:Parameter Name="Designation" Type="String" />
        <asp:Parameter Name="CompanyGroup" Type="String" />
        <asp:Parameter Name="Company" Type="String" />
        <asp:Parameter Name="Department" Type="String" />
        <asp:Parameter Name="Project" Type="String" />
        <asp:Parameter Name="Emp_Status" Type="String" />
        <asp:Parameter Name="Remarks" Type="String" />
    </SelectParameters>
    <UpdateParameters>
        <asp:Parameter  DefaultValue="0" Name="QueryType" Type="Object" />
        <asp:Parameter  DefaultValue="SaveEmployee" Name="Operation" Type="String" />
        <asp:Parameter Name="EMP_ID" Type="String" />
        <asp:Parameter Name="emp_Num" Type="String" />
        <asp:Parameter Name="FName" Type="String" />
        <asp:Parameter Name="LName" Type="String" />
        <asp:Parameter Name="Emp_Type" Type="String" />
        <asp:Parameter Name="Gender" Type="String" />
        <asp:Parameter Name="DateofBirth" Type="String" />
        <asp:Parameter Name="Designation" Type="String" />
        <asp:Parameter Name="CompanyGroup" Type="String" />
        <asp:Parameter Name="Company" Type="String" />
        <asp:Parameter Name="Department" Type="String" />
        <asp:Parameter Name="Project" Type="String" />
        <asp:Parameter Name="Emp_Status" Type="String" />
        <asp:Parameter Name="Remarks" Type="String" />
    </UpdateParameters>
</asp:ObjectDataSource>

        <asp:ObjectDataSource ID="odsDesignation" runat="server" 
        SelectMethod="QueryDatabase" TypeName="DBlookup_tableSP">
        <SelectParameters>
            <asp:Parameter DefaultValue="1" Name="QueryType" Type="Object" />
            <asp:Parameter DefaultValue="RtvDesignation" Name="Operation" Type="String" />
            <asp:Parameter Name="MAJOR" Type="String" />
            <asp:Parameter Name="MINOR" Type="String" />
            <asp:Parameter Name="DescriptionAr" Type="String" />
            <asp:Parameter Name="DescriptionEn" Type="String" />
            <asp:Parameter Name="OrderID" Type="String" />
        </SelectParameters>
    </asp:ObjectDataSource>

        <asp:ObjectDataSource ID="odsCompanyGroup" runat="server" 
        SelectMethod="QueryDatabase" TypeName="DBlookup_tableSP">
        <SelectParameters>
            <asp:Parameter DefaultValue="1" Name="QueryType" Type="Object" />
            <asp:Parameter DefaultValue="RtvCompanyGroup" Name="Operation" Type="String" />
            <asp:Parameter Name="MAJOR" Type="String" />
            <asp:Parameter Name="MINOR" Type="String" />
            <asp:Parameter Name="DescriptionAr" Type="String" />
            <asp:Parameter Name="DescriptionEn" Type="String" />
            <asp:Parameter Name="OrderID" Type="String" />
        </SelectParameters>
    </asp:ObjectDataSource>

        <asp:ObjectDataSource ID="odsCompany" runat="server" 
        SelectMethod="QueryDatabase" TypeName="DBlookup_tableSP">
        <SelectParameters>
            <asp:Parameter DefaultValue="1" Name="QueryType" Type="Object" />
            <asp:Parameter DefaultValue="RtvCompany" Name="Operation" Type="String" />
            <asp:Parameter Name="MAJOR" Type="String" />
            <asp:Parameter Name="MINOR" Type="String" />
            <asp:Parameter Name="DescriptionAr" Type="String" />
            <asp:Parameter Name="DescriptionEn" Type="String" />
            <asp:Parameter Name="OrderID" Type="String" />
        </SelectParameters>
    </asp:ObjectDataSource>

        <asp:ObjectDataSource ID="odsDepartment" runat="server" 
        SelectMethod="QueryDatabase" TypeName="DBlookup_tableSP">
        <SelectParameters>
            <asp:Parameter DefaultValue="1" Name="QueryType" Type="Object" />
            <asp:Parameter DefaultValue="RtvDepartment" Name="Operation" Type="String" />
            <asp:Parameter Name="MAJOR" Type="String" />
            <asp:Parameter Name="MINOR" Type="String" />
            <asp:Parameter Name="DescriptionAr" Type="String" />
            <asp:Parameter Name="DescriptionEn" Type="String" />
            <asp:Parameter Name="OrderID" Type="String" />
        </SelectParameters>
    </asp:ObjectDataSource>

        <asp:ObjectDataSource ID="odsProject" runat="server" 
        SelectMethod="QueryDatabase" TypeName="DBlookup_tableSP">
        <SelectParameters>
            <asp:Parameter DefaultValue="1" Name="QueryType" Type="Object" />
            <asp:Parameter DefaultValue="RtvProject" Name="Operation" Type="String" />
            <asp:Parameter Name="MAJOR" Type="String" />
            <asp:Parameter Name="MINOR" Type="String" />
            <asp:Parameter Name="DescriptionAr" Type="String" />
            <asp:Parameter Name="DescriptionEn" Type="String" />
            <asp:Parameter Name="OrderID" Type="String" />
        </SelectParameters>
    </asp:ObjectDataSource>

        <asp:ObjectDataSource ID="odsActive" runat="server" 
        SelectMethod="QueryDatabase" TypeName="DBlookup_tableSP">
        <SelectParameters>
            <asp:Parameter DefaultValue="1" Name="QueryType" Type="Object" />
            <asp:Parameter DefaultValue="RtvActive" Name="Operation" Type="String" />
            <asp:Parameter Name="MAJOR" Type="String" />
            <asp:Parameter Name="MINOR" Type="String" />
            <asp:Parameter Name="DescriptionAr" Type="String" />
            <asp:Parameter Name="DescriptionEn" Type="String" />
            <asp:Parameter Name="OrderID" Type="String" />
        </SelectParameters>
    </asp:ObjectDataSource>

        <asp:ObjectDataSource ID="odsEmp_Type" runat="server" 
        SelectMethod="QueryDatabase" TypeName="DBlookup_tableSP">
        <SelectParameters>
            <asp:Parameter DefaultValue="1" Name="QueryType" Type="Object" />
            <asp:Parameter DefaultValue="RtvEmp_Type" Name="Operation" Type="String" />
            <asp:Parameter Name="MAJOR" Type="String" />
            <asp:Parameter Name="MINOR" Type="String" />
            <asp:Parameter Name="DescriptionAr" Type="String" />
            <asp:Parameter Name="DescriptionEn" Type="String" />
            <asp:Parameter Name="OrderID" Type="String" />
        </SelectParameters>
    </asp:ObjectDataSource>

        <asp:ObjectDataSource ID="odsEmp_Status" runat="server" 
        SelectMethod="QueryDatabase" TypeName="DBlookup_tableSP">
        <SelectParameters>
            <asp:Parameter DefaultValue="1" Name="QueryType" Type="Object" />
            <asp:Parameter DefaultValue="RtvEmp_Status" Name="Operation" Type="String" />
            <asp:Parameter Name="MAJOR" Type="String" />
            <asp:Parameter Name="MINOR" Type="String" />
            <asp:Parameter Name="DescriptionAr" Type="String" />
            <asp:Parameter Name="DescriptionEn" Type="String" />
            <asp:Parameter Name="OrderID" Type="String" />
        </SelectParameters>
    </asp:ObjectDataSource>

        <asp:ObjectDataSource ID="odsGender" runat="server" 
        SelectMethod="QueryDatabase" TypeName="DBlookup_tableSP">
        <SelectParameters>
            <asp:Parameter DefaultValue="1" Name="QueryType" Type="Object" />
            <asp:Parameter DefaultValue="RtvGender" Name="Operation" Type="String" />
            <asp:Parameter Name="MAJOR" Type="String" />
            <asp:Parameter Name="MINOR" Type="String" />
            <asp:Parameter Name="DescriptionAr" Type="String" />
            <asp:Parameter Name="DescriptionEn" Type="String" />
            <asp:Parameter Name="OrderID" Type="String" />
        </SelectParameters>
    </asp:ObjectDataSource>
              

 </asp:Content>

